package org.jeecg.modules.flower.mapper;


import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.flower.entity.*;
import org.jeecg.modules.flowermater.entity.FlowerMaterialCost;

import java.util.List;

/**
 * @Description: 成本=------统计
 * @Author: jeecg-boot
 * @Date:   2022-06-29
 * @Version: V1.0
 */
public interface FlowerCostMapper extends BaseMapper<FlowerCost> {

    /**
     *
     * 查询蔬菜出库的成本
     * @param page
     * @param storehouse
     * @param cost
     * @param sDate
     * @param eDate
     * @param psnId
     * @return
     */
    IPage<FlowerCost> queryCosts(IPage<FlowerCost> page, @Param("storehouse") String storehouse, @Param("cost") String cost, @Param("sDate") String sDate, @Param("eDate") String eDate, @Param("psnId") String psnId);



    /**
     * 蔬菜明细表查询统计===盘点 上期入库
     * @param sDate
     * @return
     */
    List<FlowerAcont> huaSIN(@Param("storehouse") String storehouse, @Param("cost") String cost,  @Param("sDate") String sDate , @Param("eDate") String eDate );
   /**
     * 蔬菜明细表查询统计===盘点 上期出库
     * @param sDate
     * @return
     */
    List<FlowerAcont> huaSOut(@Param("storehouse") String storehouse, @Param("cost") String cost,  @Param("sDate") String sDate , @Param("eDate") String eDate );

    /**
     * 蔬菜明细表查询统计===盘点 本期入库
     * @param sDate
     * @param eDate
     * @return
     */
    List<FlowerAcont> huaBenQiRuKu(@Param("storehouse") String storehouse, @Param("cost") String cost,    @Param("sDate") String sDate, @Param("eDate") String eDate );

    /**
     *  蔬菜明细表查询统计===盘点 本期出库
     * @param sDate
     * @param eDate
     * @return
     */
    List<FlowerAcont> huaBenQiChuKu( @Param("storehouse") String storehouse, @Param("cost") String cost,   @Param("sDate") String sDate, @Param("eDate") String eDate );


    /**
     * 结算单汇总报表
     */
    IPage<FlowerOrderCountList> orderCountList(IPage<FlowerOrderCountList> page , @Param("ew") Wrapper<FlowerOutorder> queryWrapper, @Param("sDate") String sDate, @Param("eDate")String eDate);


    /**
     *
     * 出库汇总--给库管用的
     * @param page
     * @param queryWrapper
     * @param sDate
     * @param eDate
     * @return
     */
    IPage<FlowerAcont> huiZonglist(IPage<FlowerAcont> page , @Param("ew") Wrapper<FlowerAcont> queryWrapper,   @Param("sDate") String sDate, @Param("eDate") String eDate );


    /**
     * 预出库结算单
     * @param page
     * @param queryWrapper
     * @param sDate
     * @param eDate
     * @return
     */
    IPage<FlowerOrderPreCountList> orderPreAccontlist(IPage<FlowerOrderPreCountList> page , @Param("ew") Wrapper<FlowerOrderPreCountList> queryWrapper, @Param("sDate") String sDate, @Param("eDate") String eDate );


    /**
     * 入库汇总单
     * @descriptionauthor
     * @author gf
     * 2022-10-27 13:19
     * [page, queryWrapper, sDate, eDate]
     * @return com.baomidou.mybatisplus.core.metadata.IPage<org.jeecg.modules.flower.entity.FlowerTagIn>
     */
    IPage<TFlowerTagIn2>  queryInListByDate (IPage<TFlowerTagIn2> page , @Param("ew") Wrapper<TFlowerTagIn2> queryWrapper, @Param("sDate") String sDate, @Param("eDate") String eDate ) ;


    /**
     *  实物出库汇总报表
     * @descriptionauthor
     * @author gf
     * 2022-10-28 15:12
     * [page, isPre, sDate, eDate]String storehouse,
     * @return com.baomidou.mybatisplus.core.metadata.IPage<org.jeecg.modules.flower.entity.FlowerOutorderHZ>
     */
    IPage<FlowerOutorderHZ>  queryOutListByDate (IPage<FlowerOutorderHZ> page , @Param("storehouse")  String storehouse, @Param("isPre")  String isPre, @Param("sDate") String sDate, @Param("eDate") String eDate ) ;
/**
 *
 * @descriptionauthor 实物出库 日 报表
 * @author gf
 * 2022-11-18 16:12
 * [page, storehouse, isPre, sDate, eDate]
 * @return com.baomidou.mybatisplus.core.metadata.IPage<org.jeecg.modules.flower.entity.FlowerOutorderDayHZ>
 */
    IPage<FlowerOutorderDayHZ>  queryOutDayListByDate (IPage<FlowerOutorderDayHZ> page , @Param("storehouse")  String storehouse, @Param("isPre")  String isPre, @Param("sDate") String sDate, @Param("eDate") String eDate ) ;


    /**
     * 销售系统大屏获取-销售数据。，
     * @descriptionauthor
     * @author gf
     * 2022-11-14 13:53
     * []
     * @return java.util.List<org.jeecg.modules.flower.entity.FlowerOutorderHZ>
     */
    List<FlowerOutorderHZ>  getSealInfos () ;
    List<FlowerOutorderHZ>  getThreeMonthSealInfos () ;





}
